SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwrEnfermedades
AS
--SELECT     idEnfermedad AS ID, CAST(idEnfermedad AS VARCHAR) + ' - ' + Descripcion AS Descripcion, CodigoAlfanumerico
SELECT     idEnfermedad AS ID, RTRIM(CodigoAlfanumerico) + ' - ' + Descripcion AS Descripcion, CodigoAlfanumerico
FROM         dbo.tb_Enfermedades



GO
GRANT SELECT ON  [dbo].[vwrEnfermedades] TO [CertificacionesServicios]
GRANT SELECT ON  [dbo].[vwrEnfermedades] TO [public]
GRANT SELECT ON  [dbo].[vwrEnfermedades] TO [SoloVer]
GO
